FATAL: pg_hba.conf ::1

--0016e6d7ef85634bc70487f854a9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello:


I have been testing streaming replication on postgresql 9, and now i have
this messages in pg_log on salve.

pg_log:
2010-06-01 09:13:58 CLT LOG: el sistema de bases de datos fue interrumpido=
;
=FAltima vez en funcionamiento en 2010-06-01 09:00:17 CLT
2010-06-01 09:13:58 CLT LOG: entering standby mode
2010-06-01 09:13:58 CLT LOG: redo comienza en 0/10000020
2010-06-01 09:13:58 CLT LOG: registro de longitud cero en 0/100000A8
2010-06-01 09:13:58 CLT LOG: streaming replication successfully connected
to primary
2010-06-01 09:13:59 CLT FATAL: el sistema de base de datos est=E1 inici=E1=
ndose
2010-06-01 09:14:00 CLT FATAL: el sistema de base de datos est=E1 inici=E1=
ndose
2010-06-01 09:14:00 CLT LOG: consistent recovery state reached at
0/11000000
2010-06-01 09:14:00 CLT LOG: database system is ready to accept read only
connections
*2010-06-01 09:14:01 CLT FATAL: no hay una l=EDnea en pg_hba.conf para =AB=
::1=BB,
usuario =ABpostgres=BB, base de datos =ABpostgres=BB, SSL inactivo*
*2010-06-01 09:14:02 CLT FATAL: no hay una l=EDnea en pg_hba.conf para =AB=
::1=BB,
usuario =ABpostgres=BB, base de datos =ABpostgres=BB, SSL inactivo*


IPV6????

My pg_hba on slave:
# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
#host replication postgres 192.168.XXX.XX/16 trust
host all all 192.168.XXX.XX/16 trust
# IPv6 local connections:
#host all all ::1/128 md5

ENVIRONMENT:
DB: Postgresql 9
Master: Windows XP
Slave: Windows 2008 Server

Maybe this problem is'nt important to the replication process.. but... i
would like to resolve it...

Thanks for your help.


Fredy

--0016e6d7ef85634bc70487f854a9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello:

Re: FATAL: pg_hba.conf ::1

On Tue, Jun 1, 2010 at 7:55 AM, Fredy Ganga (GMAIL ACCOUNT)
wrote:
> Hello:
>
> I have been testing streaming replication on postgresql 9, and now i have
> this messages in pg_log on salve.
> pg_log:
> 2010-06-01 09:13:58 CLT LOG: =A0el sistema de bases de datos fue interrum=
pido;
> =FAltima vez en funcionamiento en 2010-06-01 09:00:17 CLT
> 2010-06-01 09:13:58 CLT LOG: =A0entering standby mode
> 2010-06-01 09:13:58 CLT LOG: =A0redo comienza en 0/10000020
> 2010-06-01 09:13:58 CLT LOG: =A0registro de longitud cero en 0/100000A8
> 2010-06-01 09:13:58 CLT LOG: =A0streaming replication successfully connec=
ted
> to primary
> 2010-06-01 09:13:59 CLT FATAL: =A0el sistema de base de datos est=E1 inic=
i=E1ndose
> 2010-06-01 09:14:00 CLT FATAL: =A0el sistema de base de datos est=E1 inic=
i=E1ndose
> 2010-06-01 09:14:00 CLT LOG: =A0consistent recovery state reached at
> 0/11000000
> 2010-06-01 09:14:00 CLT LOG: =A0database system is ready to accept read o=
nly
> connections
> 2010-06-01 09:14:01 CLT FATAL: =A0no hay una l=EDnea en pg_hba.conf para =
=AB::1=BB,
> usuario =ABpostgres=BB, base de datos =ABpostgres=BB, SSL inactivo
> 2010-06-01 09:14:02 CLT FATAL: =A0no hay una l=EDnea en pg_hba.conf para =
=AB::1=BB,
> usuario =ABpostgres=BB, base de datos =ABpostgres=BB, SSL inactivo
>
> IPV6????
> My pg_hba on slave:
> # TYPE =A0DATABASE =A0 =A0 =A0 =A0USER =A0 =A0 =A0 =A0 =A0 =A0CIDR-ADDRES=
S =A0 =A0 =A0 =A0 =A0 =A0METHOD
> # IPv4 local connections:
> host =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 all =A0 =A0 =A0 =A0 =A0 =A0 127.0=
..0.1/32 =A0 =A0 =A0 =A0 =A0 =A0md5
> #host replication postgres 192.168.XXX.XX/16 trust
> host all all 192.168.XXX.XX/16 trust
> # IPv6 local connections:
> #host =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 all =A0 =A0 =A0 =A0 =A0 =A0 ::1/=
128 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 md5
> ENVIRONMENT:
> DB: Postgresql 9
> Master: Windows XP
> Slave: Windows 2008 Server
> Maybe this problem is'nt important to the replication process.. but... i
> would like to resolve it...
> Thanks for your help.

Looks like it's trying to use IPv6 and there's no entries for IPv6 in
your pg_hba.conf to math.

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin